//
//  SQL_DataBase.h
//  Food
//
//  Created by dllo on 15/7/22.
//  Copyright (c) 2015年 dllo. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "HomePage_detailed_model.h"
#import "AdventureModel.h"

#import <sqlite3.h>
@interface SQL_DataBase : NSObject
{
    sqlite3 *dbPointer;
}

+ (SQL_DataBase *) shareInstance;

//创建数据/打开数据库
- (void) openDB;
//关闭数据库
- (void) closeDB;
//创建表(美食收藏)
- (void) creatTable1;
- (void) insertCollect:(HomePage_detailed_model *) model;
- (HomePage_detailed_model *) selectCollectID:(NSString *)classID;
- (void)deleteCollect:(NSString *) classid;
- (NSMutableArray *) selectCollect;

//创建表(活动收藏)
- (void) creatTable2;
- (void) insertActivity:(AdventureModel *) model;
- (AdventureModel *) selectActivityID:(NSString *)freshId;
- (void)deleteActivity:(NSString *) freshId;
- (NSMutableArray *) selectActivity;
@end
